package cn.kgc.itrip.beans.model.vo;

import lombok.Data;

/**
 * @author 阿泽
 */
@Data
public class ItripHotelCountVo {
    private Integer improve;
    private Integer isok;
    private Integer havingimg;
    private Integer allcomment;
    /**
     *  select count(isHavingImg) as havingimg from itrip_comment where isHavingImg=1 and hotelId=1 //有图片
     *  select count(content)as allcomment from itrip_comment where hotelId=1 //全部评论
     *  select count(isOk)as isok from itrip_comment where hotelId=1 and isOk=1 //值得推荐
     *  select count(isOk)as improve from itrip_comment where hotelId=1 and isOk=0//有待改善
     */
}
